CREATE DATABASE QLTHUCPHAM_FIX
GO
USE [QLTHUCPHAM_FIX]
GO
/****** Object:  Table [dbo].[Lich]    Script Date: 09/23/2013 01:06:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Lich](
	[Ma_Lich] [nchar](3) NOT NULL,
	[TenLich] [nvarchar](50) NOT NULL,
	[NgayLap] [datetime] NOT NULL,
	[NgayBatDau] [datetime] NOT NULL,
	[NgayKetThuc] [datetime] NOT NULL,
 CONSTRAINT [PK_Lich] PRIMARY KEY CLUSTERED 
(
	[Ma_Lich] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LoaiNgay]    Script Date: 09/23/2013 01:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoaiNgay](
	[Ma_Ngay] [nchar](3) NOT NULL,
	[TenNgay] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_LoaiNgay] PRIMARY KEY CLUSTERED 
(
	[Ma_Ngay] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Hop]    Script Date: 09/23/2013 01:06:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Hop](
	[MaHop] [nchar](3) NOT NULL,
	[TenHop] [nvarchar](50) NOT NULL,
	[SoLuong] [int] NOT NULL,
 CONSTRAINT [PK_Hop] PRIMARY KEY CLUSTERED 
(
	[MaHop] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LoaiMon]    Script Date: 09/23/2013 01:06:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoaiMon](
	[Ma_Loai] [nchar](3) NOT NULL,
	[TenLoai] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_LoaiMon] PRIMARY KEY CLUSTERED 
(
	[Ma_Loai] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Kho]    Script Date: 09/23/2013 01:06:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Kho](
	[Ma_NguyenLieu] [nchar](3) NOT NULL,
	[Ten_NguyenLieu] [nvarchar](50) NOT NULL,
	[DonViTinh] [nvarchar](50) NOT NULL,
	[SoLuong] [int] NOT NULL,
 CONSTRAINT [PK_Kho] PRIMARY KEY CLUSTERED 
(
	[Ma_NguyenLieu] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[LoaiNV]    Script Date: 09/23/2013 01:06:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoaiNV](
	[MaLoai] [nchar](3) NOT NULL,
	[ChucDanh] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_LoaiNV] PRIMARY KEY CLUSTERED 
(
	[MaLoai] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MonAn_Hop]    Script Date: 09/23/2013 01:06:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MonAn_Hop](
	[MaHop] [nchar](3) NOT NULL,
	[Ma_Mon] [nchar](3) NOT NULL,
	[SoLuong] [int] NOT NULL,
 CONSTRAINT [PK_MonAn_Hop] PRIMARY KEY CLUSTERED 
(
	[MaHop] ASC,
	[Ma_Mon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChiTietLich]    Script Date: 09/23/2013 01:06:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChiTietLich](
	[Ma_LichCT] [nchar](3) NOT NULL,
	[Ma_Lich] [nchar](3) NOT NULL,
	[LoaiNgay] [nchar](3) NOT NULL,
	[Ma_Mon] [nchar](3) NOT NULL,
 CONSTRAINT [PK_ChiTietLich_1] PRIMARY KEY CLUSTERED 
(
	[Ma_LichCT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MonAn]    Script Date: 09/23/2013 01:06:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MonAn](
	[Ma_Mon] [nchar](3) NOT NULL,
	[TenMon] [nvarchar](50) NOT NULL,
	[Loai] [nchar](3) NOT NULL,
	[GiaTien] [float] NULL,
 CONSTRAINT [PK_MonAn] PRIMARY KEY CLUSTERED 
(
	[Ma_Mon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ThanhPhan]    Script Date: 09/23/2013 01:06:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ThanhPhan](
	[MaNguyenLieu] [nchar](3) NOT NULL,
	[Ma_MonAn] [nchar](3) NOT NULL,
	[DonViTinh] [nchar](50) NOT NULL,
	[SoLuong] [int] NOT NULL,
 CONSTRAINT [PK_ThanhPhan] PRIMARY KEY CLUSTERED 
(
	[MaNguyenLieu] ASC,
	[Ma_MonAn] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChiTietPhieuGiao]    Script Date: 09/23/2013 01:06:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChiTietPhieuGiao](
	[MaChiTietPG] [nchar](3) NOT NULL,
	[Ma_PG] [nchar](3) NOT NULL,
	[Ma_Mon] [nchar](3) NOT NULL,
	[SoLuong] [int] NOT NULL,
	[DonGia] [float] NOT NULL,
	[SoHop] [int] NOT NULL,
 CONSTRAINT [PK_ChiTietPhieuGiao_1] PRIMARY KEY CLUSTERED 
(
	[MaChiTietPG] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[KhuyenMai]    Script Date: 09/23/2013 01:06:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KhuyenMai](
	[Ma_KhuyenMai] [nchar](3) NOT NULL,
	[Ma_MonAn] [nchar](3) NOT NULL,
	[PhanTramGiam] [int] NOT NULL,
	[NgayBatDau] [datetime] NOT NULL,
	[NgayKetThuc] [datetime] NOT NULL,
 CONSTRAINT [PK_KhuyenMai] PRIMARY KEY CLUSTERED 
(
	[Ma_KhuyenMai] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChiTietPhieuDat]    Script Date: 09/23/2013 01:06:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChiTietPhieuDat](
	[MaChiTietPD] [nchar](3) NOT NULL,
	[Ma_PD] [nchar](3) NOT NULL,
	[Ma_Mon] [nchar](3) NOT NULL,
	[SoLuong] [int] NOT NULL,
	[DonGia] [float] NOT NULL,
	[ThanhTien] [float] NOT NULL,
	[GhiChu] [nvarchar](100) NULL,
 CONSTRAINT [PK_ChiTietPhieuDat_1] PRIMARY KEY CLUSTERED 
(
	[MaChiTietPD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ThucPhamSoChe]    Script Date: 09/23/2013 01:06:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ThucPhamSoChe](
	[Ma_Mon] [nchar](3) NOT NULL,
	[GiaTien] [float] NOT NULL,
	[SoPhan] [int] NULL,
 CONSTRAINT [PK_ThucPhamSoChe] PRIMARY KEY CLUSTERED 
(
	[Ma_Mon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChiTietXuatKho]    Script Date: 09/23/2013 01:06:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChiTietXuatKho](
	[MaPhieuXuat] [nchar](3) NOT NULL,
	[MaNguyenLieu] [nchar](3) NOT NULL,
	[DonViTinh] [nvarchar](50) NOT NULL,
	[SoLuong] [int] NOT NULL,
 CONSTRAINT [PK_ChiTietXuatKho] PRIMARY KEY CLUSTERED 
(
	[MaPhieuXuat] ASC,
	[MaNguyenLieu] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChiTietNhapKho]    Script Date: 09/23/2013 01:06:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChiTietNhapKho](
	[MaPhieuNhap] [nchar](3) NOT NULL,
	[MaNguyenLieu] [nchar](3) NOT NULL,
	[DonViTinh] [nvarchar](50) NOT NULL,
	[SoLuong] [int] NOT NULL,
	[DonGia] [float] NOT NULL,
 CONSTRAINT [PK_ChiTietNhapKho] PRIMARY KEY CLUSTERED 
(
	[MaPhieuNhap] ASC,
	[MaNguyenLieu] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NhanVien]    Script Date: 09/23/2013 01:06:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NhanVien](
	[Ma_NV] [nchar](3) NOT NULL,
	[Password] [nchar](6) NOT NULL,
	[Ten_NV] [nvarchar](50) NOT NULL,
	[NgaySinh] [datetime] NOT NULL,
	[Luong] [float] NOT NULL,
	[Loai_NV] [nchar](3) NOT NULL,
 CONSTRAINT [PK_NhanVien] PRIMARY KEY CLUSTERED 
(
	[Ma_NV] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NhapKho]    Script Date: 09/23/2013 01:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NhapKho](
	[MaPhieuNhap] [nchar](3) NOT NULL,
	[NgayNhap] [datetime] NOT NULL,
	[NhanVien] [nchar](3) NOT NULL,
	[ThanhTien] [float] NOT NULL,
 CONSTRAINT [PK_NhapKho] PRIMARY KEY CLUSTERED 
(
	[MaPhieuNhap] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[XuatKho]    Script Date: 09/23/2013 01:06:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[XuatKho](
	[MaPhieuXuat] [nchar](3) NOT NULL,
	[NgayXuat] [datetime] NOT NULL,
	[NhanVien] [nchar](3) NOT NULL,
 CONSTRAINT [PK_XuatKho] PRIMARY KEY CLUSTERED 
(
	[MaPhieuXuat] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PhieuDat]    Script Date: 09/23/2013 01:06:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PhieuDat](
	[Ma_PD] [nchar](3) NOT NULL,
	[NV_Dat] [nchar](3) NOT NULL,
	[Ten_KH] [nvarchar](50) NOT NULL,
	[DiaChi] [nvarchar](100) NOT NULL,
	[DienThoai] [nvarchar](15) NOT NULL,
	[NgayDat] [datetime] NOT NULL,
	[ThanhTien] [float] NOT NULL,
	[TinhTrang] [int] NOT NULL,
	[GhiChu] [nvarchar](100) NULL,
 CONSTRAINT [PK_PhieuDat] PRIMARY KEY CLUSTERED 
(
	[Ma_PD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PhieuGiao]    Script Date: 09/23/2013 01:06:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PhieuGiao](
	[Ma_PG] [nchar](3) NOT NULL,
	[Ma_PD] [nchar](3) NOT NULL,
	[NV_Giao] [nchar](3) NOT NULL,
	[NgayGiao] [datetime] NOT NULL,
	[ThanhTien] [float] NOT NULL,
	[TinhTrang] [int] NOT NULL,
	[Ghi_Chu] [nvarchar](100) NULL,
 CONSTRAINT [PK_PhieuGiao_1] PRIMARY KEY CLUSTERED 
(
	[Ma_PG] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  ForeignKey [FK_ChiTietLich_Lich]    Script Date: 09/23/2013 01:06:04 ******/
ALTER TABLE [dbo].[ChiTietLich]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietLich_Lich] FOREIGN KEY([Ma_Lich])
REFERENCES [dbo].[Lich] ([Ma_Lich])
GO
ALTER TABLE [dbo].[ChiTietLich] CHECK CONSTRAINT [FK_ChiTietLich_Lich]
GO
/****** Object:  ForeignKey [FK_ChiTietLich_LoaiNgay]    Script Date: 09/23/2013 01:06:04 ******/
ALTER TABLE [dbo].[ChiTietLich]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietLich_LoaiNgay] FOREIGN KEY([LoaiNgay])
REFERENCES [dbo].[LoaiNgay] ([Ma_Ngay])
GO
ALTER TABLE [dbo].[ChiTietLich] CHECK CONSTRAINT [FK_ChiTietLich_LoaiNgay]
GO
/****** Object:  ForeignKey [FK_ChiTietLich_MonAn]    Script Date: 09/23/2013 01:06:04 ******/
ALTER TABLE [dbo].[ChiTietLich]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietLich_MonAn] FOREIGN KEY([Ma_Mon])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[ChiTietLich] CHECK CONSTRAINT [FK_ChiTietLich_MonAn]
GO
/****** Object:  ForeignKey [FK_ChiTietNhapKho_Kho]    Script Date: 09/23/2013 01:06:06 ******/
ALTER TABLE [dbo].[ChiTietNhapKho]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietNhapKho_Kho] FOREIGN KEY([MaNguyenLieu])
REFERENCES [dbo].[Kho] ([Ma_NguyenLieu])
GO
ALTER TABLE [dbo].[ChiTietNhapKho] CHECK CONSTRAINT [FK_ChiTietNhapKho_Kho]
GO
/****** Object:  ForeignKey [FK_ChiTietNhapKho_NhapKho]    Script Date: 09/23/2013 01:06:06 ******/
ALTER TABLE [dbo].[ChiTietNhapKho]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietNhapKho_NhapKho] FOREIGN KEY([MaPhieuNhap])
REFERENCES [dbo].[NhapKho] ([MaPhieuNhap])
GO
ALTER TABLE [dbo].[ChiTietNhapKho] CHECK CONSTRAINT [FK_ChiTietNhapKho_NhapKho]
GO
/****** Object:  ForeignKey [FK_ChiTietPhieuDat_MonAn]    Script Date: 09/23/2013 01:06:08 ******/
ALTER TABLE [dbo].[ChiTietPhieuDat]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietPhieuDat_MonAn] FOREIGN KEY([Ma_Mon])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[ChiTietPhieuDat] CHECK CONSTRAINT [FK_ChiTietPhieuDat_MonAn]
GO
/****** Object:  ForeignKey [FK_ChiTietPhieuDat_PhieuDat]    Script Date: 09/23/2013 01:06:08 ******/
ALTER TABLE [dbo].[ChiTietPhieuDat]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietPhieuDat_PhieuDat] FOREIGN KEY([Ma_PD])
REFERENCES [dbo].[PhieuDat] ([Ma_PD])
GO
ALTER TABLE [dbo].[ChiTietPhieuDat] CHECK CONSTRAINT [FK_ChiTietPhieuDat_PhieuDat]
GO
/****** Object:  ForeignKey [FK_ChiTietPhieuGiao_MonAn]    Script Date: 09/23/2013 01:06:09 ******/
ALTER TABLE [dbo].[ChiTietPhieuGiao]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietPhieuGiao_MonAn] FOREIGN KEY([Ma_Mon])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[ChiTietPhieuGiao] CHECK CONSTRAINT [FK_ChiTietPhieuGiao_MonAn]
GO
/****** Object:  ForeignKey [FK_ChiTietPhieuGiao_PhieuGiao]    Script Date: 09/23/2013 01:06:09 ******/
ALTER TABLE [dbo].[ChiTietPhieuGiao]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietPhieuGiao_PhieuGiao] FOREIGN KEY([Ma_PG])
REFERENCES [dbo].[PhieuGiao] ([Ma_PG])
GO
ALTER TABLE [dbo].[ChiTietPhieuGiao] CHECK CONSTRAINT [FK_ChiTietPhieuGiao_PhieuGiao]
GO
/****** Object:  ForeignKey [FK_ChiTietXuatKho_Kho]    Script Date: 09/23/2013 01:06:11 ******/
ALTER TABLE [dbo].[ChiTietXuatKho]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietXuatKho_Kho] FOREIGN KEY([MaNguyenLieu])
REFERENCES [dbo].[Kho] ([Ma_NguyenLieu])
GO
ALTER TABLE [dbo].[ChiTietXuatKho] CHECK CONSTRAINT [FK_ChiTietXuatKho_Kho]
GO
/****** Object:  ForeignKey [FK_ChiTietXuatKho_XuatKho]    Script Date: 09/23/2013 01:06:11 ******/
ALTER TABLE [dbo].[ChiTietXuatKho]  WITH CHECK ADD  CONSTRAINT [FK_ChiTietXuatKho_XuatKho] FOREIGN KEY([MaPhieuXuat])
REFERENCES [dbo].[XuatKho] ([MaPhieuXuat])
GO
ALTER TABLE [dbo].[ChiTietXuatKho] CHECK CONSTRAINT [FK_ChiTietXuatKho_XuatKho]
GO
/****** Object:  ForeignKey [FK_KhuyenMai_MonAn]    Script Date: 09/23/2013 01:06:17 ******/
ALTER TABLE [dbo].[KhuyenMai]  WITH CHECK ADD  CONSTRAINT [FK_KhuyenMai_MonAn] FOREIGN KEY([Ma_MonAn])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[KhuyenMai] CHECK CONSTRAINT [FK_KhuyenMai_MonAn]
GO
/****** Object:  ForeignKey [FK_MonAn_LoaiMon]    Script Date: 09/23/2013 01:06:21 ******/
ALTER TABLE [dbo].[MonAn]  WITH CHECK ADD  CONSTRAINT [FK_MonAn_LoaiMon] FOREIGN KEY([Loai])
REFERENCES [dbo].[LoaiMon] ([Ma_Loai])
GO
ALTER TABLE [dbo].[MonAn] CHECK CONSTRAINT [FK_MonAn_LoaiMon]
GO
/****** Object:  ForeignKey [FK_MonAn_Hop_Hop]    Script Date: 09/23/2013 01:06:22 ******/
ALTER TABLE [dbo].[MonAn_Hop]  WITH CHECK ADD  CONSTRAINT [FK_MonAn_Hop_Hop] FOREIGN KEY([MaHop])
REFERENCES [dbo].[Hop] ([MaHop])
GO
ALTER TABLE [dbo].[MonAn_Hop] CHECK CONSTRAINT [FK_MonAn_Hop_Hop]
GO
/****** Object:  ForeignKey [FK_MonAn_Hop_MonAn]    Script Date: 09/23/2013 01:06:23 ******/
ALTER TABLE [dbo].[MonAn_Hop]  WITH CHECK ADD  CONSTRAINT [FK_MonAn_Hop_MonAn] FOREIGN KEY([Ma_Mon])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[MonAn_Hop] CHECK CONSTRAINT [FK_MonAn_Hop_MonAn]
GO
/****** Object:  ForeignKey [FK_NhanVien_LoaiNV]    Script Date: 09/23/2013 01:06:24 ******/
ALTER TABLE [dbo].[NhanVien]  WITH CHECK ADD  CONSTRAINT [FK_NhanVien_LoaiNV] FOREIGN KEY([Loai_NV])
REFERENCES [dbo].[LoaiNV] ([MaLoai])
GO
ALTER TABLE [dbo].[NhanVien] CHECK CONSTRAINT [FK_NhanVien_LoaiNV]
GO
/****** Object:  ForeignKey [FK_NhapKho_NhanVien]    Script Date: 09/23/2013 01:06:27 ******/
ALTER TABLE [dbo].[NhapKho]  WITH CHECK ADD  CONSTRAINT [FK_NhapKho_NhanVien] FOREIGN KEY([NhanVien])
REFERENCES [dbo].[NhanVien] ([Ma_NV])
GO
ALTER TABLE [dbo].[NhapKho] CHECK CONSTRAINT [FK_NhapKho_NhanVien]
GO
/****** Object:  ForeignKey [FK_PhieuDat_NhanVien]    Script Date: 09/23/2013 01:06:30 ******/
ALTER TABLE [dbo].[PhieuDat]  WITH CHECK ADD  CONSTRAINT [FK_PhieuDat_NhanVien] FOREIGN KEY([NV_Dat])
REFERENCES [dbo].[NhanVien] ([Ma_NV])
GO
ALTER TABLE [dbo].[PhieuDat] CHECK CONSTRAINT [FK_PhieuDat_NhanVien]
GO
/****** Object:  ForeignKey [FK_PhieuGiao_NhanVien]    Script Date: 09/23/2013 01:06:32 ******/
ALTER TABLE [dbo].[PhieuGiao]  WITH CHECK ADD  CONSTRAINT [FK_PhieuGiao_NhanVien] FOREIGN KEY([NV_Giao])
REFERENCES [dbo].[NhanVien] ([Ma_NV])
GO
ALTER TABLE [dbo].[PhieuGiao] CHECK CONSTRAINT [FK_PhieuGiao_NhanVien]
GO
/****** Object:  ForeignKey [FK_PhieuGiao_PhieuDat]    Script Date: 09/23/2013 01:06:32 ******/
ALTER TABLE [dbo].[PhieuGiao]  WITH CHECK ADD  CONSTRAINT [FK_PhieuGiao_PhieuDat] FOREIGN KEY([Ma_PD])
REFERENCES [dbo].[PhieuDat] ([Ma_PD])
GO
ALTER TABLE [dbo].[PhieuGiao] CHECK CONSTRAINT [FK_PhieuGiao_PhieuDat]
GO
/****** Object:  ForeignKey [FK_ThanhPhan_Kho]    Script Date: 09/23/2013 01:06:33 ******/
ALTER TABLE [dbo].[ThanhPhan]  WITH CHECK ADD  CONSTRAINT [FK_ThanhPhan_Kho] FOREIGN KEY([MaNguyenLieu])
REFERENCES [dbo].[Kho] ([Ma_NguyenLieu])
GO
ALTER TABLE [dbo].[ThanhPhan] CHECK CONSTRAINT [FK_ThanhPhan_Kho]
GO
/****** Object:  ForeignKey [FK_ThanhPhan_MonAn]    Script Date: 09/23/2013 01:06:33 ******/
ALTER TABLE [dbo].[ThanhPhan]  WITH CHECK ADD  CONSTRAINT [FK_ThanhPhan_MonAn] FOREIGN KEY([Ma_MonAn])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[ThanhPhan] CHECK CONSTRAINT [FK_ThanhPhan_MonAn]
GO
/****** Object:  ForeignKey [FK_ThucPhamSoChe_MonAn]    Script Date: 09/23/2013 01:06:34 ******/
ALTER TABLE [dbo].[ThucPhamSoChe]  WITH CHECK ADD  CONSTRAINT [FK_ThucPhamSoChe_MonAn] FOREIGN KEY([Ma_Mon])
REFERENCES [dbo].[MonAn] ([Ma_Mon])
GO
ALTER TABLE [dbo].[ThucPhamSoChe] CHECK CONSTRAINT [FK_ThucPhamSoChe_MonAn]
GO
/****** Object:  ForeignKey [FK_XuatKho_NhanVien]    Script Date: 09/23/2013 01:06:35 ******/
ALTER TABLE [dbo].[XuatKho]  WITH CHECK ADD  CONSTRAINT [FK_XuatKho_NhanVien] FOREIGN KEY([NhanVien])
REFERENCES [dbo].[NhanVien] ([Ma_NV])
GO
ALTER TABLE [dbo].[XuatKho] CHECK CONSTRAINT [FK_XuatKho_NhanVien]
GO



--NhapLieu

--LoaiNV

INSERT INTO LOAINV VALUES ('001',N'Giám đốc')
INSERT INTO LOAINV VALUES ('002',N'Trưởng Bếp')
INSERT INTO LOAINV VALUES ('003',N'Trưởng Kho')
INSERT INTO LOAINV VALUES ('004',N'Nhân Viên')
INSERT INTO LOAINV VALUES ('005',N'Bảo Vệ')
INSERT INTO LOAINV VALUES ('006',N'Tạp Vụ')
INSERT INTO LOAINV VALUES ('007',N'Phụ Bếp')

--NHANVIEN
INSERT INTO NHANVIEN VALUES ('001','123456',N'Mai Lan Phương','5/22/1978',10000,'001')
INSERT INTO NHANVIEN VALUES ('002','123456',N'Vũ Văn Vinh','2/10/1983',8000,'003')
INSERT INTO NHANVIEN VALUES ('003','123456',N'Cao Thượng Tiến','06/13/1972',8000,'002')
INSERT INTO NHANVIEN VALUES ('004','123456',N'Nguyễn Văn Trỗi','1/25/1973',3000,'006')
INSERT INTO NHANVIEN VALUES ('005','123456',N'Cao Bá Quát','7/3/1973',3000,'006')
INSERT INTO NHANVIEN VALUES ('006','123456',N'Nguyễn Hữu Lợi','1/1/1985',3000,'005')
INSERT INTO NHANVIEN VALUES ('007','123456',N'Nguyễn Hoàng Long','8/20/1962',5000,'004')
INSERT INTO NHANVIEN VALUES ('008','123456',N'Nguyễn Hoàng Minh','5/4/1976',5000,'004')
INSERT INTO NHANVIEN VALUES ('009','123456',N'Lê Hoài Bão','5/5/1957',5000,'004')
INSERT INTO NHANVIEN VALUES ('010','123456',N'Phạm Thị Hoa','11/6/1959',3500,'007')
INSERT INTO NHANVIEN VALUES ('011','123456',N'Nguyễn Thị Thảo','7/7/1968',3500,'007')
INSERT INTO NHANVIEN VALUES ('012','123456',N'Đồng Thiện Lâm','10/25/1988',3500,'004')
INSERT INTO NHANVIEN VALUES ('013','123456',N'Lê Thanh Tùng','3/1/1977',3500,'004')



--LoaiMon
INSERT INTO LOAIMON VALUES ('001',N'Chay')
INSERT INTO LOAIMON VALUES ('002',N'Mặn')

--MONAN
INSERT INTO MONAN VALUES ('001',N'Đậu hũ dồn thịt sốt cà ','002',20000)
INSERT INTO MONAN VALUES ('002',N'Cơm vịt kho gừng','002',30000)
INSERT INTO MONAN VALUES ('003',N'Cơm sườn cốt lết nướng','002',50000)
INSERT INTO MONAN VALUES ('004',N'Cơm sườn chả trứng gà ốp la','002',63000)
INSERT INTO MONAN VALUES ('005',N'Bún riêu tôm cua','002',50000)
INSERT INTO MONAN VALUES ('006',N'Canh cua rau đay','002',20000)
INSERT INTO MONAN VALUES ('007',N'Cơm mực xào chua ngọt','002',35000)
INSERT INTO MONAN VALUES ('008',N'Cánh gà chiên nước mắm','002',55000)
INSERT INTO MONAN VALUES ('009',N'Tàu hũ ky bì chả','002',51000)
INSERT INTO MONAN VALUES ('010',N'bún thịt nướng chả giò','002',53000)
INSERT INTO MONAN VALUES ('011',N'Bánh canh giò heo','002',45000)
INSERT INTO MONAN VALUES ('012',N'Canh bí đỏ','001',22000)
INSERT INTO MONAN VALUES ('013',N'Canh khổ qua thịt','002',20000)
INSERT INTO MONAN VALUES ('014',N'Xà lách trộn dầu dấm','001',15000)
INSERT INTO MONAN VALUES ('015',N'Mì xào thập cẩm','001',35000)
INSERT INTO MONAN VALUES ('016',N'Sườn chay xào chua ngọt','001',45000)
INSERT INTO MONAN VALUES ('017',N'Tôm chay lăn bột','001',45000)
INSERT INTO MONAN VALUES ('018',N'Cháo nấm thập cẩm','001',45000)
INSERT INTO MONAN VALUES ('019',N'Bò kho chay và bánh mì','001',35000)
INSERT INTO MONAN VALUES ('020',N'Bún rieu cua chay','001',35000)

--HOP
INSERT INTO HOP VALUES ('001',N'Canh',300)
INSERT INTO HOP VALUES ('002',N'Cơm',320)
INSERT INTO HOP VALUES ('003',N'Thức ăn kèm',200)
INSERT INTO HOP VALUES ('004',N'Nước chấm',350)

--MONAN_HOP
INSERT INTO MONAN_HOP VALUES ('001','001',2)
INSERT INTO MONAN_HOP VALUES ('002','001',1)
INSERT INTO MONAN_HOP VALUES ('003','001',1)
INSERT INTO MONAN_HOP VALUES ('004','001',3)
INSERT INTO MONAN_HOP VALUES ('001','002',3)
INSERT INTO MONAN_HOP VALUES ('002','002',2)
INSERT INTO MONAN_HOP VALUES ('003','002',3)
INSERT INTO MONAN_HOP VALUES ('004','003',4)
INSERT INTO MONAN_HOP VALUES ('001','003',1)
INSERT INTO MONAN_HOP VALUES ('002','003',2)
INSERT INTO MONAN_HOP VALUES ('003','004',3)
INSERT INTO MONAN_HOP VALUES ('004','005',4)
INSERT INTO MONAN_HOP VALUES ('001','006',2)
INSERT INTO MONAN_HOP VALUES ('002','006',1)
INSERT INTO MONAN_HOP VALUES ('003','006',3)
INSERT INTO MONAN_HOP VALUES ('004','006',2)
INSERT INTO MONAN_HOP VALUES ('001','007',1)
INSERT INTO MONAN_HOP VALUES ('002','007',3)
INSERT INTO MONAN_HOP VALUES ('003','008',2)
INSERT INTO MONAN_HOP VALUES ('004','008',3)
INSERT INTO MONAN_HOP VALUES ('001','008',1)
INSERT INTO MONAN_HOP VALUES ('002','008',2)
INSERT INTO MONAN_HOP VALUES ('003','009',4)
INSERT INTO MONAN_HOP VALUES ('004','009',2)
INSERT INTO MONAN_HOP VALUES ('001','009',4)
INSERT INTO MONAN_HOP VALUES ('002','010',2)
INSERT INTO MONAN_HOP VALUES ('003','011',1)
INSERT INTO MONAN_HOP VALUES ('004','012',1)
INSERT INTO MONAN_HOP VALUES ('001','012',3)
INSERT INTO MONAN_HOP VALUES ('002','013',4)
INSERT INTO MONAN_HOP VALUES ('003','013',2)
INSERT INTO MONAN_HOP VALUES ('004','013',4)
INSERT INTO MONAN_HOP VALUES ('001','013',1)
INSERT INTO MONAN_HOP VALUES ('002','014',1)
INSERT INTO MONAN_HOP VALUES ('003','014',1)
INSERT INTO MONAN_HOP VALUES ('004','015',4)
INSERT INTO MONAN_HOP VALUES ('001','016',3)
INSERT INTO MONAN_HOP VALUES ('002','016',2)
INSERT INTO MONAN_HOP VALUES ('003','016',1)
INSERT INTO MONAN_HOP VALUES ('004','017',4)
INSERT INTO MONAN_HOP VALUES ('001','017',2)
INSERT INTO MONAN_HOP VALUES ('002','018',4)
INSERT INTO MONAN_HOP VALUES ('003','018',1)
INSERT INTO MONAN_HOP VALUES ('004','018',1)
INSERT INTO MONAN_HOP VALUES ('001','018',1)
INSERT INTO MONAN_HOP VALUES ('002','019',4)
INSERT INTO MONAN_HOP VALUES ('003','019',3)
INSERT INTO MONAN_HOP VALUES ('004','019',2)
INSERT INTO MONAN_HOP VALUES ('001','020',4)
INSERT INTO MONAN_HOP VALUES ('002','020',2)
INSERT INTO MONAN_HOP VALUES ('003','020',1)


--LOAINGAY
INSERT INTO LOAINGAY VALUES ('001',N'Thứ hai')
INSERT INTO LOAINGAY VALUES ('002',N'Thứ ba')
INSERT INTO LOAINGAY VALUES ('003',N'Thứ tư')
INSERT INTO LOAINGAY VALUES ('004',N'Thứ năm')
INSERT INTO LOAINGAY VALUES ('005',N'Thứ sáu')
INSERT INTO LOAINGAY VALUES ('006',N'Thứ bảy')
INSERT INTO LOAINGAY VALUES ('007',N'Chủ nhật - Ngày lễ')


--LICH
INSERT INTO LICH VALUES ('001',N'Tháng 4','4/1/2012','4/4/2012','5/1/2012')
INSERT INTO LICH VALUES ('002',N'Tháng 5','4/29/2012','5/2/2012','5/31/2012')
INSERT INTO LICH VALUES ('003',N'Tháng 6','5/28/2012','6/1/2012','6/15/2012')
INSERT INTO LICH VALUES ('004',N'Tháng 7','6/10/2012','6/16/2012','7/30/2012')
INSERT INTO LICH VALUES ('005',N'Tháng 8','7/31/2012','7/31/2012','8/31/2012')
INSERT INTO LICH VALUES ('006',N'Tháng 9','8/25/2012','9/1/2012','9/29/2012')
INSERT INTO LICH VALUES ('007',N'Tháng 10','8/28/2012','9/30/2012','10/31/2012')
INSERT INTO LICH VALUES ('008',N'Tháng 11','9/1/2012','11/1/2012','12/1/2012')
INSERT INTO LICH VALUES ('009',N'Tháng 12','12/1/2012','12/2/2012','12/25/2012')
INSERT INTO LICH VALUES ('010',N'Tháng 1','1/1/2013','1/3/2013','1/31/2013')
INSERT INTO LICH VALUES ('011',N'Tết','2/1/2013','2/1/2013','2/17/2013')
INSERT INTO LICH VALUES ('012',N'Tết - Lễ','3/3/2013','3/5/2013','3/31/2013')
INSERT INTO LICH VALUES ('013',N'Tháng 4','3/26/2013','4/1/2013','4/28/2013')
INSERT INTO LICH VALUES ('014',N'Tháng 5','4/30/2013','4/29/2013','5/31/2013')
INSERT INTO LICH VALUES ('015',N'Tháng 6','5/30/2013','6/1/2013','7/1/2013')
INSERT INTO LICH VALUES ('016',N'Tháng 7','6/24/2013','7/2/2013','8/1/2013')
INSERT INTO LICH VALUES ('017',N'Tháng 8','7/29/2013','8/2/2013','8/31/2013')
INSERT INTO LICH VALUES ('018',N'Tháng 9','8/10/2013','9/1/2013','9/29/2013')
INSERT INTO LICH VALUES ('019',N'Tháng 10','8/16/2013','9/30/2013','10/31/2013')



--CHITIETLICH
INSERT INTO CHITIETLICH VALUES ('001','001','001','006')
INSERT INTO CHITIETLICH VALUES ('002','001','001','011')
INSERT INTO CHITIETLICH VALUES ('003','001','001','008')
INSERT INTO CHITIETLICH VALUES ('004','001','001','002')
INSERT INTO CHITIETLICH VALUES ('005','001','001','007')
INSERT INTO CHITIETLICH VALUES ('006','001','002','019')
INSERT INTO CHITIETLICH VALUES ('007','001','002','009')
INSERT INTO CHITIETLICH VALUES ('008','001','002','017')
INSERT INTO CHITIETLICH VALUES ('009','001','002','001')
INSERT INTO CHITIETLICH VALUES ('010','001','003','001')
INSERT INTO CHITIETLICH VALUES ('011','001','003','015')
INSERT INTO CHITIETLICH VALUES ('012','001','003','019')
INSERT INTO CHITIETLICH VALUES ('013','001','003','003')
INSERT INTO CHITIETLICH VALUES ('014','001','003','002')
INSERT INTO CHITIETLICH VALUES ('015','001','004','016')
INSERT INTO CHITIETLICH VALUES ('016','001','004','012')
INSERT INTO CHITIETLICH VALUES ('017','001','004','011')
INSERT INTO CHITIETLICH VALUES ('018','001','005','014')
INSERT INTO CHITIETLICH VALUES ('019','001','005','004')
INSERT INTO CHITIETLICH VALUES ('020','001','005','005')
INSERT INTO CHITIETLICH VALUES ('021','001','005','013')
INSERT INTO CHITIETLICH VALUES ('022','001','006','020')
INSERT INTO CHITIETLICH VALUES ('023','001','006','010')
INSERT INTO CHITIETLICH VALUES ('024','001','006','018')
INSERT INTO CHITIETLICH VALUES ('025','001','007','020')
INSERT INTO CHITIETLICH VALUES ('026','001','007','001')
INSERT INTO CHITIETLICH VALUES ('027','002','001','006')
INSERT INTO CHITIETLICH VALUES ('028','002','001','017')
INSERT INTO CHITIETLICH VALUES ('029','002','001','008')
INSERT INTO CHITIETLICH VALUES ('030','002','001','002')
INSERT INTO CHITIETLICH VALUES ('031','002','001','007')
INSERT INTO CHITIETLICH VALUES ('032','002','002','019')
INSERT INTO CHITIETLICH VALUES ('033','002','002','009')
INSERT INTO CHITIETLICH VALUES ('034','002','002','011')
INSERT INTO CHITIETLICH VALUES ('035','002','002','001')
INSERT INTO CHITIETLICH VALUES ('036','002','003','001')
INSERT INTO CHITIETLICH VALUES ('037','002','003','015')
INSERT INTO CHITIETLICH VALUES ('038','002','003','019')
INSERT INTO CHITIETLICH VALUES ('039','002','003','012')
INSERT INTO CHITIETLICH VALUES ('040','002','003','011')
INSERT INTO CHITIETLICH VALUES ('041','002','004','016')
INSERT INTO CHITIETLICH VALUES ('042','002','004','002')
INSERT INTO CHITIETLICH VALUES ('043','002','004','003')
INSERT INTO CHITIETLICH VALUES ('044','002','005','014')
INSERT INTO CHITIETLICH VALUES ('045','002','005','004')
INSERT INTO CHITIETLICH VALUES ('046','002','005','005')
INSERT INTO CHITIETLICH VALUES ('047','002','005','013')
INSERT INTO CHITIETLICH VALUES ('048','002','006','020')
INSERT INTO CHITIETLICH VALUES ('049','002','006','010')
INSERT INTO CHITIETLICH VALUES ('050','002','006','001')
INSERT INTO CHITIETLICH VALUES ('051','002','007','020')
INSERT INTO CHITIETLICH VALUES ('052','002','007','018')
INSERT INTO CHITIETLICH VALUES ('053','003','001','006')
INSERT INTO CHITIETLICH VALUES ('054','003','001','011')
INSERT INTO CHITIETLICH VALUES ('055','003','001','016')
INSERT INTO CHITIETLICH VALUES ('056','003','001','016')
INSERT INTO CHITIETLICH VALUES ('057','003','001','007')
INSERT INTO CHITIETLICH VALUES ('058','003','002','019')
INSERT INTO CHITIETLICH VALUES ('059','003','002','009')
INSERT INTO CHITIETLICH VALUES ('060','003','002','017')
INSERT INTO CHITIETLICH VALUES ('061','003','002','001')
INSERT INTO CHITIETLICH VALUES ('062','003','003','001')
INSERT INTO CHITIETLICH VALUES ('063','003','003','020')
INSERT INTO CHITIETLICH VALUES ('064','003','003','001')
INSERT INTO CHITIETLICH VALUES ('065','003','003','003')
INSERT INTO CHITIETLICH VALUES ('066','003','003','002')
INSERT INTO CHITIETLICH VALUES ('067','003','004','008')
INSERT INTO CHITIETLICH VALUES ('068','003','004','002')
INSERT INTO CHITIETLICH VALUES ('069','003','004','011')
INSERT INTO CHITIETLICH VALUES ('070','003','005','014')
INSERT INTO CHITIETLICH VALUES ('071','003','005','004')
INSERT INTO CHITIETLICH VALUES ('072','003','005','005')
INSERT INTO CHITIETLICH VALUES ('073','003','005','013')
INSERT INTO CHITIETLICH VALUES ('074','003','006','020')
INSERT INTO CHITIETLICH VALUES ('075','003','006','010')
INSERT INTO CHITIETLICH VALUES ('076','003','006','018')
INSERT INTO CHITIETLICH VALUES ('077','003','007','015')
INSERT INTO CHITIETLICH VALUES ('078','003','007','019')
INSERT INTO CHITIETLICH VALUES ('079','004','001','006')
INSERT INTO CHITIETLICH VALUES ('080','004','001','011')
INSERT INTO CHITIETLICH VALUES ('081','004','001','008')
INSERT INTO CHITIETLICH VALUES ('082','004','001','002')
INSERT INTO CHITIETLICH VALUES ('083','004','001','015')
INSERT INTO CHITIETLICH VALUES ('084','004','002','016')
INSERT INTO CHITIETLICH VALUES ('085','004','002','012')
INSERT INTO CHITIETLICH VALUES ('086','004','002','011')
INSERT INTO CHITIETLICH VALUES ('087','004','002','001')
INSERT INTO CHITIETLICH VALUES ('088','004','003','001')
INSERT INTO CHITIETLICH VALUES ('089','004','003','007')
INSERT INTO CHITIETLICH VALUES ('090','004','003','019')
INSERT INTO CHITIETLICH VALUES ('091','004','003','003')
INSERT INTO CHITIETLICH VALUES ('092','004','003','002')
INSERT INTO CHITIETLICH VALUES ('093','004','004','019')
INSERT INTO CHITIETLICH VALUES ('094','004','004','009')
INSERT INTO CHITIETLICH VALUES ('095','004','004','017')
INSERT INTO CHITIETLICH VALUES ('096','004','005','014')
INSERT INTO CHITIETLICH VALUES ('097','004','005','004')
INSERT INTO CHITIETLICH VALUES ('098','004','005','005')
INSERT INTO CHITIETLICH VALUES ('099','004','005','013')
INSERT INTO CHITIETLICH VALUES ('100','004','006','020')
INSERT INTO CHITIETLICH VALUES ('101','004','006','010')
INSERT INTO CHITIETLICH VALUES ('102','004','006','018')
INSERT INTO CHITIETLICH VALUES ('103','004','007','020')
INSERT INTO CHITIETLICH VALUES ('104','004','007','001')
INSERT INTO CHITIETLICH VALUES ('105','005','001','001')
INSERT INTO CHITIETLICH VALUES ('106','005','001','015')
INSERT INTO CHITIETLICH VALUES ('107','005','001','019')
INSERT INTO CHITIETLICH VALUES ('108','005','001','003')
INSERT INTO CHITIETLICH VALUES ('109','005','001','002')
INSERT INTO CHITIETLICH VALUES ('110','005','002','019')
INSERT INTO CHITIETLICH VALUES ('111','005','002','009')
INSERT INTO CHITIETLICH VALUES ('112','005','002','017')
INSERT INTO CHITIETLICH VALUES ('113','005','002','001')
INSERT INTO CHITIETLICH VALUES ('114','005','003','006')
INSERT INTO CHITIETLICH VALUES ('115','005','003','011')
INSERT INTO CHITIETLICH VALUES ('116','005','003','008')
INSERT INTO CHITIETLICH VALUES ('117','005','003','002')
INSERT INTO CHITIETLICH VALUES ('118','005','003','007')
INSERT INTO CHITIETLICH VALUES ('119','005','004','020')
INSERT INTO CHITIETLICH VALUES ('120','005','004','010')
INSERT INTO CHITIETLICH VALUES ('121','005','004','001')
INSERT INTO CHITIETLICH VALUES ('122','005','005','014')
INSERT INTO CHITIETLICH VALUES ('123','005','005','004')
INSERT INTO CHITIETLICH VALUES ('124','005','005','005')
INSERT INTO CHITIETLICH VALUES ('125','005','005','013')
INSERT INTO CHITIETLICH VALUES ('126','005','006','012')
INSERT INTO CHITIETLICH VALUES ('127','005','006','010')
INSERT INTO CHITIETLICH VALUES ('128','005','006','018')
INSERT INTO CHITIETLICH VALUES ('129','005','007','020')
INSERT INTO CHITIETLICH VALUES ('130','005','007','018')
INSERT INTO CHITIETLICH VALUES ('131','006','001','006')
INSERT INTO CHITIETLICH VALUES ('132','006','001','011')
INSERT INTO CHITIETLICH VALUES ('133','006','001','008')
INSERT INTO CHITIETLICH VALUES ('134','006','001','002')
INSERT INTO CHITIETLICH VALUES ('135','006','001','007')
INSERT INTO CHITIETLICH VALUES ('136','006','002','019')
INSERT INTO CHITIETLICH VALUES ('137','006','002','009')
INSERT INTO CHITIETLICH VALUES ('138','006','002','017')
INSERT INTO CHITIETLICH VALUES ('139','006','002','001')
INSERT INTO CHITIETLICH VALUES ('140','006','003','001')
INSERT INTO CHITIETLICH VALUES ('141','006','003','015')
INSERT INTO CHITIETLICH VALUES ('142','006','003','019')
INSERT INTO CHITIETLICH VALUES ('143','006','003','003')
INSERT INTO CHITIETLICH VALUES ('144','006','003','002')
INSERT INTO CHITIETLICH VALUES ('145','006','004','016')
INSERT INTO CHITIETLICH VALUES ('146','006','004','012')
INSERT INTO CHITIETLICH VALUES ('147','006','004','011')
INSERT INTO CHITIETLICH VALUES ('148','006','005','014')
INSERT INTO CHITIETLICH VALUES ('149','006','005','004')
INSERT INTO CHITIETLICH VALUES ('150','006','005','005')
INSERT INTO CHITIETLICH VALUES ('151','006','005','013')
INSERT INTO CHITIETLICH VALUES ('152','006','006','020')
INSERT INTO CHITIETLICH VALUES ('153','006','006','010')
INSERT INTO CHITIETLICH VALUES ('154','006','006','018')
INSERT INTO CHITIETLICH VALUES ('155','006','007','020')
INSERT INTO CHITIETLICH VALUES ('156','006','007','001')
INSERT INTO CHITIETLICH VALUES ('157','007','001','006')
INSERT INTO CHITIETLICH VALUES ('158','007','001','011')
INSERT INTO CHITIETLICH VALUES ('159','007','001','008')
INSERT INTO CHITIETLICH VALUES ('160','007','001','002')
INSERT INTO CHITIETLICH VALUES ('161','007','001','007')
INSERT INTO CHITIETLICH VALUES ('162','007','002','019')
INSERT INTO CHITIETLICH VALUES ('163','007','002','009')
INSERT INTO CHITIETLICH VALUES ('164','007','002','017')
INSERT INTO CHITIETLICH VALUES ('165','007','002','001')
INSERT INTO CHITIETLICH VALUES ('166','007','003','001')
INSERT INTO CHITIETLICH VALUES ('167','007','003','015')
INSERT INTO CHITIETLICH VALUES ('168','007','003','019')
INSERT INTO CHITIETLICH VALUES ('169','007','003','003')
INSERT INTO CHITIETLICH VALUES ('170','007','003','002')
INSERT INTO CHITIETLICH VALUES ('171','007','004','016')
INSERT INTO CHITIETLICH VALUES ('172','007','004','012')
INSERT INTO CHITIETLICH VALUES ('173','007','004','011')
INSERT INTO CHITIETLICH VALUES ('174','007','005','014')
INSERT INTO CHITIETLICH VALUES ('175','007','005','004')
INSERT INTO CHITIETLICH VALUES ('176','007','005','005')
INSERT INTO CHITIETLICH VALUES ('177','007','005','013')
INSERT INTO CHITIETLICH VALUES ('178','007','006','020')
INSERT INTO CHITIETLICH VALUES ('179','007','006','010')
INSERT INTO CHITIETLICH VALUES ('180','007','006','018')
INSERT INTO CHITIETLICH VALUES ('181','007','007','020')
INSERT INTO CHITIETLICH VALUES ('182','007','007','001')
INSERT INTO CHITIETLICH VALUES ('183','008','001','006')
INSERT INTO CHITIETLICH VALUES ('184','008','001','011')
INSERT INTO CHITIETLICH VALUES ('185','008','001','008')
INSERT INTO CHITIETLICH VALUES ('186','008','001','002')
INSERT INTO CHITIETLICH VALUES ('187','008','001','007')
INSERT INTO CHITIETLICH VALUES ('188','008','002','019')
INSERT INTO CHITIETLICH VALUES ('189','008','002','009')
INSERT INTO CHITIETLICH VALUES ('190','008','002','017')
INSERT INTO CHITIETLICH VALUES ('191','008','002','001')
INSERT INTO CHITIETLICH VALUES ('192','008','003','001')
INSERT INTO CHITIETLICH VALUES ('193','008','003','015')
INSERT INTO CHITIETLICH VALUES ('194','008','003','019')
INSERT INTO CHITIETLICH VALUES ('195','008','003','003')
INSERT INTO CHITIETLICH VALUES ('196','008','003','002')
INSERT INTO CHITIETLICH VALUES ('197','008','004','016')
INSERT INTO CHITIETLICH VALUES ('198','008','004','012')
INSERT INTO CHITIETLICH VALUES ('199','008','004','011')
INSERT INTO CHITIETLICH VALUES ('200','008','005','014')
INSERT INTO CHITIETLICH VALUES ('201','008','005','004')
INSERT INTO CHITIETLICH VALUES ('202','008','005','005')
INSERT INTO CHITIETLICH VALUES ('203','008','005','013')
INSERT INTO CHITIETLICH VALUES ('204','008','006','020')
INSERT INTO CHITIETLICH VALUES ('205','008','006','010')
INSERT INTO CHITIETLICH VALUES ('206','008','006','018')
INSERT INTO CHITIETLICH VALUES ('207','008','007','020')
INSERT INTO CHITIETLICH VALUES ('208','008','007','001')
INSERT INTO CHITIETLICH VALUES ('209','009','001','006')
INSERT INTO CHITIETLICH VALUES ('210','009','001','011')
INSERT INTO CHITIETLICH VALUES ('211','009','001','008')
INSERT INTO CHITIETLICH VALUES ('212','009','001','002')
INSERT INTO CHITIETLICH VALUES ('213','009','001','007')
INSERT INTO CHITIETLICH VALUES ('214','009','002','019')
INSERT INTO CHITIETLICH VALUES ('215','009','002','009')
INSERT INTO CHITIETLICH VALUES ('216','009','002','017')
INSERT INTO CHITIETLICH VALUES ('217','009','002','001')
INSERT INTO CHITIETLICH VALUES ('218','009','003','001')
INSERT INTO CHITIETLICH VALUES ('219','009','003','015')
INSERT INTO CHITIETLICH VALUES ('220','009','003','019')
INSERT INTO CHITIETLICH VALUES ('221','009','003','003')
INSERT INTO CHITIETLICH VALUES ('222','009','003','002')
INSERT INTO CHITIETLICH VALUES ('223','009','004','016')
INSERT INTO CHITIETLICH VALUES ('224','009','004','012')
INSERT INTO CHITIETLICH VALUES ('225','009','004','011')
INSERT INTO CHITIETLICH VALUES ('226','009','005','014')
INSERT INTO CHITIETLICH VALUES ('227','009','005','004')
INSERT INTO CHITIETLICH VALUES ('228','009','005','005')
INSERT INTO CHITIETLICH VALUES ('229','009','005','013')
INSERT INTO CHITIETLICH VALUES ('230','009','006','020')
INSERT INTO CHITIETLICH VALUES ('231','009','006','010')
INSERT INTO CHITIETLICH VALUES ('232','009','006','018')
INSERT INTO CHITIETLICH VALUES ('233','009','007','020')
INSERT INTO CHITIETLICH VALUES ('234','009','007','001')
INSERT INTO CHITIETLICH VALUES ('235','010','001','006')
INSERT INTO CHITIETLICH VALUES ('236','010','001','011')
INSERT INTO CHITIETLICH VALUES ('237','010','001','008')
INSERT INTO CHITIETLICH VALUES ('238','010','001','002')
INSERT INTO CHITIETLICH VALUES ('239','010','001','007')
INSERT INTO CHITIETLICH VALUES ('240','010','002','019')
INSERT INTO CHITIETLICH VALUES ('241','010','002','009')
INSERT INTO CHITIETLICH VALUES ('242','010','002','017')
INSERT INTO CHITIETLICH VALUES ('243','010','002','001')
INSERT INTO CHITIETLICH VALUES ('244','010','003','001')
INSERT INTO CHITIETLICH VALUES ('245','010','003','015')
INSERT INTO CHITIETLICH VALUES ('246','010','003','019')
INSERT INTO CHITIETLICH VALUES ('247','010','003','003')
INSERT INTO CHITIETLICH VALUES ('248','010','003','002')
INSERT INTO CHITIETLICH VALUES ('249','010','004','016')
INSERT INTO CHITIETLICH VALUES ('250','010','004','012')
INSERT INTO CHITIETLICH VALUES ('251','010','004','011')
INSERT INTO CHITIETLICH VALUES ('252','010','005','014')
INSERT INTO CHITIETLICH VALUES ('253','010','005','004')
INSERT INTO CHITIETLICH VALUES ('254','010','005','005')
INSERT INTO CHITIETLICH VALUES ('255','010','005','013')
INSERT INTO CHITIETLICH VALUES ('256','010','006','020')
INSERT INTO CHITIETLICH VALUES ('257','010','006','010')
INSERT INTO CHITIETLICH VALUES ('258','010','006','018')
INSERT INTO CHITIETLICH VALUES ('259','010','007','020')
INSERT INTO CHITIETLICH VALUES ('260','010','007','001')
INSERT INTO CHITIETLICH VALUES ('261','011','001','006')
INSERT INTO CHITIETLICH VALUES ('262','011','001','011')
INSERT INTO CHITIETLICH VALUES ('263','011','001','008')
INSERT INTO CHITIETLICH VALUES ('264','011','001','002')
INSERT INTO CHITIETLICH VALUES ('265','011','001','007')
INSERT INTO CHITIETLICH VALUES ('266','011','002','019')
INSERT INTO CHITIETLICH VALUES ('267','011','002','009')
INSERT INTO CHITIETLICH VALUES ('268','011','002','017')
INSERT INTO CHITIETLICH VALUES ('269','011','002','001')
INSERT INTO CHITIETLICH VALUES ('270','011','003','001')
INSERT INTO CHITIETLICH VALUES ('271','011','003','015')
INSERT INTO CHITIETLICH VALUES ('272','011','003','019')
INSERT INTO CHITIETLICH VALUES ('273','011','003','003')
INSERT INTO CHITIETLICH VALUES ('274','011','003','002')
INSERT INTO CHITIETLICH VALUES ('275','011','004','016')
INSERT INTO CHITIETLICH VALUES ('276','011','004','012')
INSERT INTO CHITIETLICH VALUES ('277','011','004','011')
INSERT INTO CHITIETLICH VALUES ('278','011','005','014')
INSERT INTO CHITIETLICH VALUES ('279','011','005','004')
INSERT INTO CHITIETLICH VALUES ('280','011','005','005')
INSERT INTO CHITIETLICH VALUES ('281','011','005','013')
INSERT INTO CHITIETLICH VALUES ('282','011','006','020')
INSERT INTO CHITIETLICH VALUES ('283','011','006','010')
INSERT INTO CHITIETLICH VALUES ('284','011','006','018')
INSERT INTO CHITIETLICH VALUES ('285','011','007','020')
INSERT INTO CHITIETLICH VALUES ('286','011','007','001')
INSERT INTO CHITIETLICH VALUES ('287','012','001','006')
INSERT INTO CHITIETLICH VALUES ('288','012','001','011')
INSERT INTO CHITIETLICH VALUES ('289','012','001','008')
INSERT INTO CHITIETLICH VALUES ('290','012','001','002')
INSERT INTO CHITIETLICH VALUES ('291','012','001','007')
INSERT INTO CHITIETLICH VALUES ('292','012','002','019')
INSERT INTO CHITIETLICH VALUES ('293','012','002','009')
INSERT INTO CHITIETLICH VALUES ('294','012','002','017')
INSERT INTO CHITIETLICH VALUES ('295','012','002','001')
INSERT INTO CHITIETLICH VALUES ('296','012','003','001')
INSERT INTO CHITIETLICH VALUES ('297','012','003','015')
INSERT INTO CHITIETLICH VALUES ('298','012','003','019')
INSERT INTO CHITIETLICH VALUES ('299','012','003','003')
INSERT INTO CHITIETLICH VALUES ('300','012','003','002')
INSERT INTO CHITIETLICH VALUES ('301','012','004','016')
INSERT INTO CHITIETLICH VALUES ('302','012','004','012')
INSERT INTO CHITIETLICH VALUES ('303','012','004','011')
INSERT INTO CHITIETLICH VALUES ('304','012','005','014')
INSERT INTO CHITIETLICH VALUES ('305','012','005','004')
INSERT INTO CHITIETLICH VALUES ('306','012','005','005')
INSERT INTO CHITIETLICH VALUES ('307','012','005','013')
INSERT INTO CHITIETLICH VALUES ('308','012','006','020')
INSERT INTO CHITIETLICH VALUES ('309','012','006','010')
INSERT INTO CHITIETLICH VALUES ('310','012','006','018')
INSERT INTO CHITIETLICH VALUES ('311','012','007','020')
INSERT INTO CHITIETLICH VALUES ('312','012','007','001')
INSERT INTO CHITIETLICH VALUES ('313','013','001','006')
INSERT INTO CHITIETLICH VALUES ('314','013','001','011')
INSERT INTO CHITIETLICH VALUES ('315','013','001','008')
INSERT INTO CHITIETLICH VALUES ('316','013','001','002')
INSERT INTO CHITIETLICH VALUES ('317','013','001','007')
INSERT INTO CHITIETLICH VALUES ('318','013','002','019')
INSERT INTO CHITIETLICH VALUES ('319','013','002','009')
INSERT INTO CHITIETLICH VALUES ('320','013','002','017')
INSERT INTO CHITIETLICH VALUES ('321','013','002','001')
INSERT INTO CHITIETLICH VALUES ('322','013','003','001')
INSERT INTO CHITIETLICH VALUES ('323','013','003','015')
INSERT INTO CHITIETLICH VALUES ('324','013','003','019')
INSERT INTO CHITIETLICH VALUES ('325','013','003','003')
INSERT INTO CHITIETLICH VALUES ('326','013','003','002')
INSERT INTO CHITIETLICH VALUES ('327','013','004','016')
INSERT INTO CHITIETLICH VALUES ('328','013','004','012')
INSERT INTO CHITIETLICH VALUES ('329','013','004','011')
INSERT INTO CHITIETLICH VALUES ('330','013','005','014')
INSERT INTO CHITIETLICH VALUES ('331','013','005','004')
INSERT INTO CHITIETLICH VALUES ('332','013','005','005')
INSERT INTO CHITIETLICH VALUES ('333','013','005','013')
INSERT INTO CHITIETLICH VALUES ('334','013','006','020')
INSERT INTO CHITIETLICH VALUES ('335','013','006','010')
INSERT INTO CHITIETLICH VALUES ('336','013','006','018')
INSERT INTO CHITIETLICH VALUES ('337','013','007','020')
INSERT INTO CHITIETLICH VALUES ('338','013','007','001')
INSERT INTO CHITIETLICH VALUES ('339','014','001','006')
INSERT INTO CHITIETLICH VALUES ('340','014','001','011')
INSERT INTO CHITIETLICH VALUES ('341','014','001','008')
INSERT INTO CHITIETLICH VALUES ('342','014','001','002')
INSERT INTO CHITIETLICH VALUES ('343','014','001','007')
INSERT INTO CHITIETLICH VALUES ('344','014','002','019')
INSERT INTO CHITIETLICH VALUES ('345','014','002','009')
INSERT INTO CHITIETLICH VALUES ('346','014','002','017')
INSERT INTO CHITIETLICH VALUES ('347','014','002','001')
INSERT INTO CHITIETLICH VALUES ('348','014','003','001')
INSERT INTO CHITIETLICH VALUES ('349','014','003','015')
INSERT INTO CHITIETLICH VALUES ('350','014','003','019')
INSERT INTO CHITIETLICH VALUES ('351','014','003','003')
INSERT INTO CHITIETLICH VALUES ('352','014','003','002')
INSERT INTO CHITIETLICH VALUES ('353','014','004','016')
INSERT INTO CHITIETLICH VALUES ('354','014','004','012')
INSERT INTO CHITIETLICH VALUES ('355','014','004','011')
INSERT INTO CHITIETLICH VALUES ('356','014','005','014')
INSERT INTO CHITIETLICH VALUES ('357','014','005','004')
INSERT INTO CHITIETLICH VALUES ('358','014','005','005')
INSERT INTO CHITIETLICH VALUES ('359','014','005','013')
INSERT INTO CHITIETLICH VALUES ('360','014','006','020')
INSERT INTO CHITIETLICH VALUES ('361','014','006','010')
INSERT INTO CHITIETLICH VALUES ('362','014','006','018')
INSERT INTO CHITIETLICH VALUES ('363','014','007','020')
INSERT INTO CHITIETLICH VALUES ('364','014','007','001')
INSERT INTO CHITIETLICH VALUES ('365','015','001','006')
INSERT INTO CHITIETLICH VALUES ('366','015','001','011')
INSERT INTO CHITIETLICH VALUES ('367','015','001','008')
INSERT INTO CHITIETLICH VALUES ('368','015','001','002')
INSERT INTO CHITIETLICH VALUES ('369','015','001','007')
INSERT INTO CHITIETLICH VALUES ('370','015','002','019')
INSERT INTO CHITIETLICH VALUES ('371','015','002','009')
INSERT INTO CHITIETLICH VALUES ('372','015','002','017')
INSERT INTO CHITIETLICH VALUES ('373','015','002','001')
INSERT INTO CHITIETLICH VALUES ('374','015','003','001')
INSERT INTO CHITIETLICH VALUES ('375','015','003','015')
INSERT INTO CHITIETLICH VALUES ('376','015','003','019')
INSERT INTO CHITIETLICH VALUES ('377','015','003','003')
INSERT INTO CHITIETLICH VALUES ('378','015','003','002')
INSERT INTO CHITIETLICH VALUES ('379','015','004','016')
INSERT INTO CHITIETLICH VALUES ('380','015','004','012')
INSERT INTO CHITIETLICH VALUES ('381','015','004','011')
INSERT INTO CHITIETLICH VALUES ('382','015','005','014')
INSERT INTO CHITIETLICH VALUES ('383','015','005','004')
INSERT INTO CHITIETLICH VALUES ('384','015','005','005')
INSERT INTO CHITIETLICH VALUES ('385','015','005','013')
INSERT INTO CHITIETLICH VALUES ('386','015','006','020')
INSERT INTO CHITIETLICH VALUES ('387','015','006','010')
INSERT INTO CHITIETLICH VALUES ('388','015','006','018')
INSERT INTO CHITIETLICH VALUES ('389','015','007','020')
INSERT INTO CHITIETLICH VALUES ('390','015','007','001')
INSERT INTO CHITIETLICH VALUES ('391','016','001','006')
INSERT INTO CHITIETLICH VALUES ('392','016','001','011')
INSERT INTO CHITIETLICH VALUES ('393','016','001','009')
INSERT INTO CHITIETLICH VALUES ('394','016','001','002')
INSERT INTO CHITIETLICH VALUES ('395','016','001','007')
INSERT INTO CHITIETLICH VALUES ('396','016','002','019')
INSERT INTO CHITIETLICH VALUES ('397','016','002','008')
INSERT INTO CHITIETLICH VALUES ('398','016','002','017')
INSERT INTO CHITIETLICH VALUES ('399','016','002','001')
INSERT INTO CHITIETLICH VALUES ('400','016','003','001')
INSERT INTO CHITIETLICH VALUES ('401','016','003','013')
INSERT INTO CHITIETLICH VALUES ('402','016','003','019')
INSERT INTO CHITIETLICH VALUES ('403','016','003','003')
INSERT INTO CHITIETLICH VALUES ('404','016','003','002')
INSERT INTO CHITIETLICH VALUES ('405','016','004','016')
INSERT INTO CHITIETLICH VALUES ('406','016','004','020')
INSERT INTO CHITIETLICH VALUES ('407','016','004','011')
INSERT INTO CHITIETLICH VALUES ('408','016','005','014')
INSERT INTO CHITIETLICH VALUES ('409','016','005','004')
INSERT INTO CHITIETLICH VALUES ('410','016','005','005')
INSERT INTO CHITIETLICH VALUES ('411','016','005','015')
INSERT INTO CHITIETLICH VALUES ('412','016','006','012')
INSERT INTO CHITIETLICH VALUES ('413','016','006','010')
INSERT INTO CHITIETLICH VALUES ('414','016','006','018')
INSERT INTO CHITIETLICH VALUES ('415','016','007','020')
INSERT INTO CHITIETLICH VALUES ('416','016','007','001')
INSERT INTO CHITIETLICH VALUES ('417','017','001','006')
INSERT INTO CHITIETLICH VALUES ('418','017','001','011')
INSERT INTO CHITIETLICH VALUES ('419','017','001','016')
INSERT INTO CHITIETLICH VALUES ('420','017','001','018')
INSERT INTO CHITIETLICH VALUES ('421','017','001','007')
INSERT INTO CHITIETLICH VALUES ('422','017','002','019')
INSERT INTO CHITIETLICH VALUES ('423','017','002','009')
INSERT INTO CHITIETLICH VALUES ('424','017','002','017')
INSERT INTO CHITIETLICH VALUES ('425','017','002','001')
INSERT INTO CHITIETLICH VALUES ('426','017','003','001')
INSERT INTO CHITIETLICH VALUES ('427','017','003','010')
INSERT INTO CHITIETLICH VALUES ('428','017','003','002')
INSERT INTO CHITIETLICH VALUES ('429','017','003','020')
INSERT INTO CHITIETLICH VALUES ('430','017','003','001')
INSERT INTO CHITIETLICH VALUES ('431','017','004','008')
INSERT INTO CHITIETLICH VALUES ('432','017','004','012')
INSERT INTO CHITIETLICH VALUES ('433','017','004','011')
INSERT INTO CHITIETLICH VALUES ('434','017','005','014')
INSERT INTO CHITIETLICH VALUES ('435','017','005','004')
INSERT INTO CHITIETLICH VALUES ('436','017','005','005')
INSERT INTO CHITIETLICH VALUES ('437','017','005','013')
INSERT INTO CHITIETLICH VALUES ('438','017','006','002')
INSERT INTO CHITIETLICH VALUES ('439','017','006','016')
INSERT INTO CHITIETLICH VALUES ('440','017','006','012')
INSERT INTO CHITIETLICH VALUES ('441','017','007','011')
INSERT INTO CHITIETLICH VALUES ('442','017','007','001')
INSERT INTO CHITIETLICH VALUES ('443','018','001','017')
INSERT INTO CHITIETLICH VALUES ('444','018','001','001')
INSERT INTO CHITIETLICH VALUES ('445','018','001','006')
INSERT INTO CHITIETLICH VALUES ('446','018','001','015')
INSERT INTO CHITIETLICH VALUES ('447','018','001','007')
INSERT INTO CHITIETLICH VALUES ('448','018','002','019')
INSERT INTO CHITIETLICH VALUES ('449','018','002','009')
INSERT INTO CHITIETLICH VALUES ('450','018','002','006')
INSERT INTO CHITIETLICH VALUES ('451','018','002','011')
INSERT INTO CHITIETLICH VALUES ('452','018','003','008')
INSERT INTO CHITIETLICH VALUES ('453','018','003','012')
INSERT INTO CHITIETLICH VALUES ('454','018','003','007')
INSERT INTO CHITIETLICH VALUES ('455','018','003','003')
INSERT INTO CHITIETLICH VALUES ('456','018','003','002')
INSERT INTO CHITIETLICH VALUES ('457','018','004','016')
INSERT INTO CHITIETLICH VALUES ('458','018','004','004')
INSERT INTO CHITIETLICH VALUES ('459','018','004','011')
INSERT INTO CHITIETLICH VALUES ('460','018','005','014')
INSERT INTO CHITIETLICH VALUES ('461','018','005','016')
INSERT INTO CHITIETLICH VALUES ('462','018','005','005')
INSERT INTO CHITIETLICH VALUES ('463','018','005','013')
INSERT INTO CHITIETLICH VALUES ('464','018','006','020')
INSERT INTO CHITIETLICH VALUES ('465','018','006','010')
INSERT INTO CHITIETLICH VALUES ('466','018','006','018')
INSERT INTO CHITIETLICH VALUES ('467','018','007','020')
INSERT INTO CHITIETLICH VALUES ('468','018','007','001')
INSERT INTO CHITIETLICH VALUES ('469','019','001','001')
INSERT INTO CHITIETLICH VALUES ('470','019','001','005')
INSERT INTO CHITIETLICH VALUES ('471','019','001','013')
INSERT INTO CHITIETLICH VALUES ('472','019','001','002')
INSERT INTO CHITIETLICH VALUES ('473','019','001','007')
INSERT INTO CHITIETLICH VALUES ('474','019','002','019')
INSERT INTO CHITIETLICH VALUES ('475','019','002','009')
INSERT INTO CHITIETLICH VALUES ('476','019','002','017')
INSERT INTO CHITIETLICH VALUES ('477','019','002','001')
INSERT INTO CHITIETLICH VALUES ('478','019','003','006')
INSERT INTO CHITIETLICH VALUES ('479','019','003','011')
INSERT INTO CHITIETLICH VALUES ('480','019','003','003')
INSERT INTO CHITIETLICH VALUES ('481','019','003','008')
INSERT INTO CHITIETLICH VALUES ('482','019','003','002')
INSERT INTO CHITIETLICH VALUES ('483','019','004','004')
INSERT INTO CHITIETLICH VALUES ('484','019','004','015')
INSERT INTO CHITIETLICH VALUES ('485','019','004','011')
INSERT INTO CHITIETLICH VALUES ('486','019','005','014')
INSERT INTO CHITIETLICH VALUES ('487','019','005','016')
INSERT INTO CHITIETLICH VALUES ('488','019','005','012')
INSERT INTO CHITIETLICH VALUES ('489','019','005','019')
INSERT INTO CHITIETLICH VALUES ('490','019','006','020')
INSERT INTO CHITIETLICH VALUES ('491','019','006','010')
INSERT INTO CHITIETLICH VALUES ('492','019','006','018')
INSERT INTO CHITIETLICH VALUES ('493','019','007','010')
INSERT INTO CHITIETLICH VALUES ('494','019','007','018')


--KHUYENMAI
INSERT INTO KhuyenMai VALUES ('001','005','5','5/30/2013','6/30/2013')
INSERT INTO KhuyenMai VALUES ('002','007','5','5/30/2013','6/30/2013')
INSERT INTO KhuyenMai VALUES ('003','009','5','7/1/2013','7/7/2013')
INSERT INTO KhuyenMai VALUES ('004','010','5','7/7/2013','7/14/2013')
INSERT INTO KhuyenMai VALUES ('005','005','15','10/9/2013','10/9/2013')
INSERT INTO KhuyenMai VALUES ('006','005','18','10/1/2013','10/2/2013')
INSERT INTO KhuyenMai VALUES ('007','006','45','10/9/2013','10/9/2013')
INSERT INTO KhuyenMai VALUES ('010','007','43','10/9/2013','10/9/2013')
INSERT INTO KhuyenMai VALUES ('011','009','15','10/12/2013','10/14/2013')
INSERT INTO KhuyenMai VALUES ('012','001','12','10/29/2013','10/29/2013')

--PHIEUDAT
INSERT INTO PhieuDat VALUES ('001','001',N'Nguyễn Văn Hiếu',N'17 Trường Chinh Quận 12, TPHCM','3 839 2212','2/9/2013',78000,1,N'')
INSERT INTO PhieuDat VALUES ('002','001',N'Hồ Thanh Liêm',N'25 CMT8, Quận 3, TPHCM','3 817 2245','9/2/2013',153600,0,N'Giảm giá món 5:5 %')
INSERT INTO PhieuDat VALUES ('003','002',N'Lê Văn Hành',N'2bis Nguyễn Bỉnh Khiêm, Đa Kao, Quận 1, Ho Chi Minh','3 825 7497','10/9/2013',54000,1,N'')
INSERT INTO PhieuDat VALUES ('004','002',N'Hồ Thị Cẩm Đào',N'122 Phan Xích Long, P.2, Q.Phú Nhuận, Tp. Hồ Chí Minh','3 784 5112','8/15/2013',288000,0,N'')
INSERT INTO PhieuDat VALUES ('005','002',N'Liêu Thái Bảo',N'154-156-158 Nguyễn Tất Thành, P.13, Q.4, TP.HCM','3 784 7777','7/26/2013',130800,1,N'Giảm giá món 5:5 %')
INSERT INTO PhieuDat VALUES ('006','004',N'Trần Bình Trọng',N'139 Nguyễn Văn Trỗi P12 Q. PN','3 968 4157','9/9/2013',118800,0,N'Giảm giá món 7:5 %')
INSERT INTO PhieuDat VALUES ('007','004',N'Nguyễn Hoàn Mai Anh',N'235-237-239-241 Cộng Hòa, P.13, Q.Tân Bình','3 888 8888','8/9/2013',129600,1,N'Giảm giá món 7:5 %')
INSERT INTO PhieuDat VALUES ('008','005',N'Lê Vũ Thanh Hải',N'372 Lê Văn Sỹ P14 Q3','3 547 9682','2/9/2013',81000,0,N'')
INSERT INTO PhieuDat VALUES ('009','001',N'Hoàng Lê Kim Tuấn',N'92 An Dương Vương,F9, Q.5','3 778 7798','2/9/2013',135000,1,N'')
INSERT INTO PhieuDat VALUES ('010','003',N'Vũ Khắc Duy',N'68 Bạch Đằng P24 Q.Bình Thạnh HCM','3 747 7755','5/9/2013',236000,0,N'')


--CHITIETPHIEUDAT
INSERT INTO ChiTietPhieuDat VALUES ('001','001','001',1,24000,24000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('002','001','002',2,27000,54000,N'Nhiều ớt')
INSERT INTO ChiTietPhieuDat VALUES ('003','002','003',2,27000,54000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('004','002','004',2,27000,54000,N'Nhiều trứng')
INSERT INTO ChiTietPhieuDat VALUES ('005','002','005',2,24000,48000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('006','003','002',2,27000,54000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('007','004','001',3,24000,72000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('008','004','002',4,27000,108000,N'Ít ớt')
INSERT INTO ChiTietPhieuDat VALUES ('009','004','003',4,27000,108000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('010','005','006',4,27000,108000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('011','005','005',1,24000,24000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('012','006','007',1,24000,24000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('013','006','005',2,24000,48000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('014','006','012',2,24000,48000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('015','007','007',2,24000,48000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('016','007','008',3,29000,87000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('017','008','014',3,27000,81000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('018','009','014',5,27000,135000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('019','010','001',1,24000,24000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('020','010','008',1,29000,29000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('021','010','016',2,24000,48000,N'')
INSERT INTO ChiTietPhieuDat VALUES ('022','010','013',5,27000,135000,N'')


--PHIEUGIAO
INSERT INTO PhieuGiao VALUES ('001','001','001','2/9/2013',78000,1,N'')
INSERT INTO PhieuGiao VALUES ('002','002','005','9/2/2013',153600,0,N'Giảm giá món 5:5 %')
INSERT INTO PhieuGiao VALUES ('003','003','004','10/9/2013',54000,1,N'')
INSERT INTO PhieuGiao VALUES ('004','004','002','8/15/2013',288000,0,N'')
INSERT INTO PhieuGiao VALUES ('005','005','005','7/26/2013',130800,1,N'Giảm giá món 5:5 %')
INSERT INTO PhieuGiao VALUES ('006','006','002','9/9/2013',118800,0,N'Giảm giá món 7:5 %')
INSERT INTO PhieuGiao VALUES ('007','007','002','8/9/2013',129600,1,N'Giảm giá món 7:5 %')
INSERT INTO PhieuGiao VALUES ('008','008','003','2/9/2013',81000,0,N'')
INSERT INTO PhieuGiao VALUES ('009','009','003','2/9/2013',135000,1,N'')
INSERT INTO PhieuGiao VALUES ('010','010','001','5/9/2013',236000,0,N'')


--CHITIETPHIEUGIAO
INSERT INTO ChiTietPhieuGiao VALUES ('001','001','001',1,24000,1)
INSERT INTO ChiTietPhieuGiao VALUES ('002','001','002',2,27000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('003','002','003',2,27000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('004','002','004',2,27000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('005','002','005',2,24000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('006','003','002',2,27000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('007','004','001',3,24000,3)
INSERT INTO ChiTietPhieuGiao VALUES ('008','004','002',4,27000,4)
INSERT INTO ChiTietPhieuGiao VALUES ('009','004','003',4,27000,4)
INSERT INTO ChiTietPhieuGiao VALUES ('010','005','006',4,27000,4)
INSERT INTO ChiTietPhieuGiao VALUES ('011','005','005',1,24000,1)
INSERT INTO ChiTietPhieuGiao VALUES ('012','006','007',1,24000,1)
INSERT INTO ChiTietPhieuGiao VALUES ('013','006','005',2,24000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('014','006','012',2,24000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('015','007','007',2,24000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('016','007','008',3,29000,3)
INSERT INTO ChiTietPhieuGiao VALUES ('017','008','014',3,27000,3)
INSERT INTO ChiTietPhieuGiao VALUES ('018','009','014',5,27000,5)
INSERT INTO ChiTietPhieuGiao VALUES ('019','010','001',1,24000,1)
INSERT INTO ChiTietPhieuGiao VALUES ('020','010','008',1,29000,1)
INSERT INTO ChiTietPhieuGiao VALUES ('021','010','016',2,24000,2)
INSERT INTO ChiTietPhieuGiao VALUES ('022','010','013',5,27000,5)


--KHO
INSERT INTO KHO VALUES ('001',N'Mực',N'Kg',50)
INSERT INTO KHO VALUES ('002',N'Sườn cốt lết heo',N'Kg',100)
INSERT INTO KHO VALUES ('003',N'Cánh gà',N'Kg',50)
INSERT INTO KHO VALUES ('004',N'Đậu hũ',N'Miếng',60)
INSERT INTO KHO VALUES ('005',N'Giò heo',N'Kg',30)
INSERT INTO KHO VALUES ('006',N'Xương heo',N'Kg',40)
INSERT INTO KHO VALUES ('007',N'Trứng gà',N'Trái',100)
INSERT INTO KHO VALUES ('008',N'Vịt',N'Kg',50)
INSERT INTO KHO VALUES ('009',N'Tôm',N'Kg',40)
INSERT INTO KHO VALUES ('010',N'Thịt cua',N'Kg',40)
INSERT INTO KHO VALUES ('011',N'Tàu hũ ky',N'Kg',70)
INSERT INTO KHO VALUES ('012',N'Rau đay',N'Kg',20)
INSERT INTO KHO VALUES ('013',N'Bí đỏ',N'Kg',50)
INSERT INTO KHO VALUES ('014',N'Khổ qua',N'Kg',30)
INSERT INTO KHO VALUES ('015',N'Xà lách',N'Kg',50)
INSERT INTO KHO VALUES ('016',N'Mì trứng tươi',N'Kg',20)
INSERT INTO KHO VALUES ('017',N'Sườn chay',N'Kg',40)
INSERT INTO KHO VALUES ('018',N'Tôm chay',N'Kg',20)
INSERT INTO KHO VALUES ('019',N'Cua chay',N'Kg',20)
INSERT INTO KHO VALUES ('020',N'Nấm rơm',N'Kg',20)
INSERT INTO KHO VALUES ('021',N'Nấm đông cô tươi',N'Kg',20)
INSERT INTO KHO VALUES ('022',N'Nấm linh chi tươi',N'Kg',20)
INSERT INTO KHO VALUES ('023',N'Nấm kim châm tươi',N'Kg',20)
INSERT INTO KHO VALUES ('024',N'Thịt heo bằm',N'Kg',15)


--NHAPKHO
INSERT INTO NHAPKHO VALUES ('001','1/1/2013','001',10000000)
INSERT INTO NHAPKHO VALUES ('002','2/1/2013','002',20000000)
INSERT INTO NHAPKHO VALUES ('003','3/3/2013','006',15000000)
INSERT INTO NHAPKHO VALUES ('004','3/26/2013','004',30000000)
INSERT INTO NHAPKHO VALUES ('005','4/30/2013','002',9000000)
INSERT INTO NHAPKHO VALUES ('006','5/30/2013','006',13000000)
INSERT INTO NHAPKHO VALUES ('007','6/24/2013','001',40000000)
INSERT INTO NHAPKHO VALUES ('008','7/29/2013','008',25000000)
INSERT INTO NHAPKHO VALUES ('009','9/1/2013','007',34000000)
INSERT INTO NHAPKHO VALUES ('010','9/30/2013','010',10000000)



--CHITIETNHAPKHO
INSERT INTO CHITIETNHAPKHO VALUES ('001','001',N'Kg',50,250000)
INSERT INTO CHITIETNHAPKHO VALUES ('002','001',N'Kg',50,250000)
INSERT INTO CHITIETNHAPKHO VALUES ('006','001',N'Kg',50,250000)
INSERT INTO CHITIETNHAPKHO VALUES ('001','002',N'Kg',150,350000)
INSERT INTO CHITIETNHAPKHO VALUES ('003','003',N'Kg',50,130000)
INSERT INTO CHITIETNHAPKHO VALUES ('007','003',N'Kg',50,130000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','004',N'Miếng',100,200000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','005',N'Kg',60,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('006','006',N'Kg',40,20000)
INSERT INTO CHITIETNHAPKHO VALUES ('002','007',N'Trái',100,3000)
INSERT INTO CHITIETNHAPKHO VALUES ('008','008',N'Kg',50,250000)
INSERT INTO CHITIETNHAPKHO VALUES ('002','009',N'Kg',50,200000)
INSERT INTO CHITIETNHAPKHO VALUES ('003','010',N'Kg',40,200000)
INSERT INTO CHITIETNHAPKHO VALUES ('005','010',N'Kg',40,200000)
INSERT INTO CHITIETNHAPKHO VALUES ('009','010',N'Kg',30,200000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','011',N'Kg',70,45000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','012',N'Kg',20,20000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','013',N'Kg',30,15000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','014',N'Kg',30,40000)
INSERT INTO CHITIETNHAPKHO VALUES ('005','014',N'Kg',30,40000)
INSERT INTO CHITIETNHAPKHO VALUES ('001','015',N'Kg',50,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('002','015',N'Kg',50,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('006','015',N'Kg',50,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('001','016',N'Kg',20,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('002','016',N'Kg',20,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('008','016',N'Kg',20,35000)
INSERT INTO CHITIETNHAPKHO VALUES ('002','017',N'Kg',40,150000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','018',N'Kg',19,130000)
INSERT INTO CHITIETNHAPKHO VALUES ('001','019',N'Kg',20,150000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','019',N'Kg',20,150000)
INSERT INTO CHITIETNHAPKHO VALUES ('007','019',N'Kg',20,150000)
INSERT INTO CHITIETNHAPKHO VALUES ('001','020',N'Kg',20,100000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','020',N'Kg',20,100000)
INSERT INTO CHITIETNHAPKHO VALUES ('005','020',N'Kg',20,100000)
INSERT INTO CHITIETNHAPKHO VALUES ('007','020',N'Kg',20,100000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','021',N'Kg',20,260000)
INSERT INTO CHITIETNHAPKHO VALUES ('008','021',N'Kg',5,260000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','022',N'Kg',20,90000)
INSERT INTO CHITIETNHAPKHO VALUES ('010','022',N'Kg',5,90000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','023',N'Kg',30,70000)
INSERT INTO CHITIETNHAPKHO VALUES ('010','023',N'Kg',10,70000)
INSERT INTO CHITIETNHAPKHO VALUES ('001','024',N'Kg',15,180000)
INSERT INTO CHITIETNHAPKHO VALUES ('004','024',N'Kg',15,180000)
INSERT INTO CHITIETNHAPKHO VALUES ('008','024',N'Kg',15,180000)



--XUATKHO
INSERT INTO XUATKHO VALUES ('001','1/1/2013','002')
INSERT INTO XUATKHO VALUES ('002','2/1/2013','006')
INSERT INTO XUATKHO VALUES ('003','3/3/2013','004')
INSERT INTO XUATKHO VALUES ('004','3/26/2013','002')
INSERT INTO XUATKHO VALUES ('005','4/30/2013','006')
INSERT INTO XUATKHO VALUES ('006','5/30/2013','001')
INSERT INTO XUATKHO VALUES ('007','6/24/2013','008')
INSERT INTO XUATKHO VALUES ('008','7/29/2013','007')
INSERT INTO XUATKHO VALUES ('009','9/1/2013','010')
INSERT INTO XUATKHO VALUES ('010','9/30/2013','002')


--CHITIETXUATKHO
INSERT INTO CHITIETXUATKHO VALUES ('001','001',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('002','001',N'Kg',48)
INSERT INTO CHITIETXUATKHO VALUES ('006','001',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('001','002',N'Kg',90)
INSERT INTO CHITIETXUATKHO VALUES ('002','002',N'Kg',100)
INSERT INTO CHITIETXUATKHO VALUES ('003','003',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('007','003',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('004','004',N'Miếng',50)
INSERT INTO CHITIETXUATKHO VALUES ('005','005',N'Kg',60)
INSERT INTO CHITIETXUATKHO VALUES ('006','006',N'Kg',40)
INSERT INTO CHITIETXUATKHO VALUES ('007','007',N'Trái',100)
INSERT INTO CHITIETXUATKHO VALUES ('008','008',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('001','009',N'Kg',40)
INSERT INTO CHITIETXUATKHO VALUES ('005','010',N'Kg',40)
INSERT INTO CHITIETXUATKHO VALUES ('009','010',N'Kg',80)
INSERT INTO CHITIETXUATKHO VALUES ('004','011',N'Kg',70)
INSERT INTO CHITIETXUATKHO VALUES ('004','012',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('004','013',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('003','014',N'Kg',30)
INSERT INTO CHITIETXUATKHO VALUES ('005','014',N'Kg',30)
INSERT INTO CHITIETXUATKHO VALUES ('001','015',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('002','015',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('006','015',N'Kg',50)
INSERT INTO CHITIETXUATKHO VALUES ('001','016',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('002','016',N'Kg',18)
INSERT INTO CHITIETXUATKHO VALUES ('008','016',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('001','019',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('004','019',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('007','019',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('001','020',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('004','020',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('005','020',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('007','020',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('004','018',N'Kg',19)
INSERT INTO CHITIETXUATKHO VALUES ('002','017',N'Kg',40)
INSERT INTO CHITIETXUATKHO VALUES ('004','021',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('008','021',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('004','022',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('010','022',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('004','023',N'Kg',20)
INSERT INTO CHITIETXUATKHO VALUES ('010','023',N'Kg',30)
INSERT INTO CHITIETXUATKHO VALUES ('001','024',N'Kg',15)
INSERT INTO CHITIETXUATKHO VALUES ('004','024',N'Kg',15)
INSERT INTO CHITIETXUATKHO VALUES ('008','024',N'Kg',15)


--THANHPHAN
INSERT INTO ThanhPhan VALUES ('004','001',N'Miếng',2)
INSERT INTO ThanhPhan VALUES ('002','003',N'Kg',0.25)
INSERT INTO ThanhPhan VALUES ('002','004',N'Kg',0.25)
INSERT INTO ThanhPhan VALUES ('007','004',N'Trái',1)
INSERT INTO ThanhPhan VALUES ('010','005',N'Kg',0.2)
INSERT INTO ThanhPhan VALUES ('010','006',N'Kg',0.1)
INSERT INTO ThanhPhan VALUES ('012','006',N'Kg',0.2)
INSERT INTO ThanhPhan VALUES ('001','007',N'Kg',0.2)
INSERT INTO ThanhPhan VALUES ('005','011',N'Kg',0.3)
INSERT INTO ThanhPhan VALUES ('013','012',N'Kg',0.3)
INSERT INTO ThanhPhan VALUES ('014','013',N'Kg',0.2)
INSERT INTO ThanhPhan VALUES ('023','013',N'Kg',0.2)
INSERT INTO ThanhPhan VALUES ('023','015',N'Kg',0.1)
INSERT INTO ThanhPhan VALUES ('017','016',N'Kg',0.1)
INSERT INTO ThanhPhan VALUES ('021','018',N'Kg',0.05)
INSERT INTO ThanhPhan VALUES ('022','018',N'Kg',0.05)
INSERT INTO ThanhPhan VALUES ('023','018',N'Kg',0.05)
INSERT INTO ThanhPhan VALUES ('019','020',N'Kg',0.1)


--THUCPHAMSOCHE
INSERT INTO ThucPhamSoChe VALUES ('001',35000,50)
INSERT INTO ThucPhamSoChe VALUES ('002',30000,100)
INSERT INTO ThucPhamSoChe VALUES ('003',50000,120)
INSERT INTO ThucPhamSoChe VALUES ('004',55000,120)
INSERT INTO ThucPhamSoChe VALUES ('005',50000,100)
INSERT INTO ThucPhamSoChe VALUES ('006',10000,100)
INSERT INTO ThucPhamSoChe VALUES ('007',45000,260)
INSERT INTO ThucPhamSoChe VALUES ('008',55000,100)
INSERT INTO ThucPhamSoChe VALUES ('009',51000,100)
INSERT INTO ThucPhamSoChe VALUES ('010',53000,100)
INSERT INTO ThucPhamSoChe VALUES ('011',45000,200)
INSERT INTO ThucPhamSoChe VALUES ('012',7000,100)
INSERT INTO ThucPhamSoChe VALUES ('013',15000,75)
INSERT INTO ThucPhamSoChe VALUES ('014',15000,100)
INSERT INTO ThucPhamSoChe VALUES ('015',30000,50)
INSERT INTO ThucPhamSoChe VALUES ('016',30000,200)
INSERT INTO ThucPhamSoChe VALUES ('017',45000,100)
INSERT INTO ThucPhamSoChe VALUES ('018',40000,100)
INSERT INTO ThucPhamSoChe VALUES ('019',35000,100)
INSERT INTO ThucPhamSoChe VALUES ('020',45000,200)

